package cn.hxzy.teacher.mapper;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

@Component
public interface SelectClassMapper {
    //获取创建人
    @Select("select nick_name from sys_user where user_id=#{userId}")
    String getCreateNameById(Integer userId);

    //获取课程数量
    @Select("select count(1) from sys_class_menu where class_id=#{classId}")
    Integer getCourseNum(Integer classId);

    //班级id获取学员数量
    @Select("select count(1) from sys_user_class where class_id=#{classId}")
    Integer getstudentNum(Integer classId);

}
